/*删除导入时产生的临时表*/
DROP TABLE IF EXISTS Di_goods_inventory;
DROP TABLE IF EXISTS DITempopen_brand;
DROP TABLE IF EXISTS DITempopen_color; 
DROP TABLE IF EXISTS DITempopen_goods; 
DROP TABLE IF EXISTS DITempopen_goods_color; 
DROP TABLE IF EXISTS DITempopen_goods_inventory; 
DROP TABLE IF EXISTS DITempopen_goods_size;
DROP TABLE IF EXISTS DITempopen_season ;
DROP TABLE IF EXISTS DITempopen_series ;
DROP TABLE IF EXISTS DITempopen_size ;
DROP TABLE IF EXISTS DITempopen_tmdzb ;
DROP TABLE IF EXISTS DITempopen_vipset ; 
/*删除导入时产生的临时表*/

 


/*删除基本档案信息*/ 
delete from open_brand;             
delete from open_color;  
delete from open_season ;           
delete from open_series ;           
delete from open_size ;             
delete from open_tmdzb ;            
delete from open_vipset ; 
delete from open_goods;             
delete from open_goods_color;       
delete from open_goods_inventory;   
delete from open_goods_size;  
/*删除基本档案信息*/

/*删除订单数据*/ 
delete from open_order_info;
delete from open_order_goods;
delete from open_order_action;

delete from open_order_return;
delete from open_order_return_goods;
delete from open_order_return_action; 
/**删除订单数据**/  
 
